Mysql number of tables in DB
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'databasename'; |
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'databasename'; |
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'databasename';